| Clone | |
| Equals | (Inherited from Object) |
| Finalize | (Inherited from Object) |
| Find(String) | Returns all occurrences of the specified text in the whole workbook, including the cells of all worksheets, the comments, the headers, the footers and the text of all shapes. Formulas are not searched. |
| Find(String, FindOptions) | Returns all occurrences of the specified text. |
| FindElementsT | Returns all objects of the specified type, for example all cells, all comments or all shapes, from the whole workbook. |
| FindElementsT(PredicateT) | Returns all objects of the specified type which match the specified condition. |
| FindElementsT(PredicateT, SearchScope) | Returns all objects of the specified type which match the specified condition. |
| FindFirst(String) | Returns the first occurrence of the specified text or null if the text was not found. |
| FindFirst(String, FindOptions) | Returns the first occurrence of the specified text or null if the text was not found. |
| GetBytes | (Overrides OfficeDocumentGetBytes) |
| GetCells | |
| GetCsv | Returns the content of all worksheets as comma separated values. Each worksheet is preceded by an empty line and its name, the cells of a row are separated by a comma and the rows are separated by a line break. A field which contains a comma, a quotation mark or a line break is enclosed in quotation marks and an embedded quotation mark is doubled, as specified by RFC 4180. |
| GetHashCode | (Inherited from Object) |
| GetHtml | Converts the workbook to HTML format. Images are embedded in the document. |
| GetStream | (Overrides OfficeDocumentGetStream) |
| GetType | (Inherited from Object) |
| LoadFromXls(Stream) | Loads an XLS workbook from a stream. See LoadFromXls(String). |
| LoadFromXls(String) | Loads an XLS (Microsoft Excel 97-2003 binary, BIFF8) workbook and reconstructs its worksheets and cell values (text, numbers, booleans, errors and formula results) into this Workbook. |
| MemberwiseClone | (Inherited from Object) |
| Open(Stream) | (Overrides OfficeDocumentOpen(Stream)) |
| Open(String) | (Overrides OfficeDocumentOpen(String)) |
| Remove | Removes the specified sheet, row, cell, comment or run from the collection it belongs to. |
| Replace(IListString, IListString) | Replaces all occurrences of the specified oldText with newText. |
| Replace(String, Run) | Replaces all occurrences of the specified text with a copy of the specified run. A cell which holds plain text is converted into a rich text cell, the text before and after the replaced text keeps its format. |
| Replace(String, IListRun) | Replaces all occurrences of the specified text with copies of the specified runs. |
| Replace(String, String) | Replaces all occurrences of the specified oldText with newText in the whole workbook. The format of the cells and the properties of all runs remain unchanged. Formulas are not changed. |
| Replace(IListString, IListString, FindOptions) | Replaces all occurrences of the specified oldText with newText. |
| Replace(String, Run, FindOptions) | Replaces all occurrences of the specified text with a copy of the specified run. |
| Replace(String, IListRun, FindOptions) | Replaces all occurrences of the specified text with copies of the specified runs. |
| Replace(String, String, FindOptions) | Replaces all occurrences of the specified oldText with newText. |
| Save(Stream) | (Overrides OfficeDocumentSave(Stream)) |
| Save(String) | (Overrides OfficeDocumentSave(String)) |
| Save(String, Boolean) | (Overrides OfficeDocumentSave(String, Boolean)) |
| SaveAsHtml(Stream) | Saves the workbook in HTML format. Images are embedded in the document, so the result is a single self-contained file. |
| SaveAsHtml(String) | Saves the workbook in HTML format. |
| SaveAsHtml(String, Boolean) | Saves the workbook in HTML format. |
| ToString | (Overrides ObjectToString) |
| Validate | Checks the workbook for the things that stop Excel opening an .xlsx, and returns what it finds. An empty list means nothing known is wrong. This is NOT a schema validator: it knows the invariants this object model can express - a workbook needs a sheet, sheet names are constrained and unique - and nothing beyond them. A workbook that passes here can still be rejected for something only a full implementation of the spec would catch, so keep validating output with an independent reader as well. |